<template>
    <div class="p-2">
      <transition :enter-active-class="proxy?.animate.searchAnimate.enter" :leave-active-class="proxy?.animate.searchAnimate.leave">
        <div class="search" v-show="showSearch">
          <el-form :model="queryParams" ref="queryFormRef" :inline="true" label-width="68px">
            <el-form-item label="姓名" prop="name">
              <el-input v-model="queryParams.name" placeholder="请输入姓名" clearable style="width: 240px" @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="学号" prop="studentNumber">
              <el-input v-model="queryParams.studentNumber" placeholder="请输入学号" clearable style="width: 240px" @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="科目" prop="subject">
              <el-input v-model="queryParams.subject" placeholder="请输入科目" clearable style="width: 240px" @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="成绩" prop="score">
              <el-input v-model="queryParams.score" placeholder="请输入成绩" clearable style="width: 240px" @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="科目排名" prop="subjectRanking">
              <el-input v-model="queryParams.subjectRanking" placeholder="请输入科目排名" clearable style="width: 240px" @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="班级排名" prop="classRanking">
              <el-input v-model="queryParams.classRanking" placeholder="请输入班级排名" clearable style="width: 240px" @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="学校排名" prop="schoolRanking">
              <el-input v-model="queryParams.schoolRanking" placeholder="请输入学校排名" clearable style="width: 240px" @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="联考排名" prop="jointRanking">
              <el-input v-model="queryParams.jointRanking" placeholder="请输入联考排名" clearable style="width: 240px" @keyup.enter="handleQuery" />
            </el-form-item>
            <el-form-item label="所属档案" prop="recordId">
              <el-select v-model="form.recordId" placeholder="请选择档案" clearable style="width: 240px" @keyup.enter="handleQuery">
                <el-option v-for="(value,index) in recordList" :key="index" :label="value.title" :value="value.id"></el-option>
              </el-select>
            </el-form-item>
            <el-form-item label="所属班级" prop="lightenId">
              <el-select v-model="queryParams.lightenId" placeholder="请选择班级" clearable style="width: 240px" @keyup.enter="handleQuery">
                <el-option v-for="(value,index) in lightenList" :key="index" :label="value.name" :value="value.id"></el-option>
              </el-select>
            </el-form-item>
            <el-form-item>
              <el-button type="primary" icon="Search" @click="handleQuery">搜索</el-button>
              <el-button icon="Refresh" @click="resetQuery">重置</el-button>
            </el-form-item>
          </el-form>
        </div>
      </transition>
  
      <el-card shadow="never">
        <template #header>
          <el-row :gutter="10" class="mb8">
            <el-col :span="1.5">
              <el-button type="primary" plain icon="Plus" @click="handleAdd" v-hasPermi="['school:score:add']">新增</el-button>
            </el-col>
            <el-col :span="1.5">
              <el-button type="success" plain icon="Edit" :disabled="single" @click="handleUpdate()" v-hasPermi="['school:score:edit']">修改</el-button>
            </el-col>
            <el-col :span="1.5">
              <el-button type="danger" plain icon="Delete" :disabled="multiple" @click="handleDelete()" v-hasPermi="['school:score:remove']">删除</el-button>
            </el-col>
            <el-col :span="1.5">
              <el-button type="warning" plain icon="Download" @click="handleExport" v-hasPermi="['school:score:export']">导出</el-button>
            </el-col>
            
            <el-col :span="1.5">
                <el-dropdown class="mt-[1px]">
                  <el-button plain type="info">
                    更多
                    <el-icon class="el-icon--right"><arrow-down /></el-icon
                  ></el-button>
                  <template #dropdown>
                    <el-dropdown-menu>
                      <el-dropdown-item @click="importTemplate" icon="Download">下载模板</el-dropdown-item>
                      <el-dropdown-item @click="handleImport" icon="Top"> 导入数据</el-dropdown-item>
                      <el-dropdown-item @click="handleExport" icon="Download"> 导出数据</el-dropdown-item>
                    </el-dropdown-menu>
                  </template>
                </el-dropdown>
              </el-col>
              <right-toolbar v-model:showSearch="showSearch" @queryTable="getList"></right-toolbar>
            </el-row>
        </template>
  
        <el-table v-loading="loading" :data="scoreList" @selection-change="handleSelectionChange">
          <el-table-column type="selection" width="55" align="center" />
          <el-table-column label="" align="center" prop="id" v-if="false" />
          <el-table-column label="学号" align="center" prop="studentNumber" />
          <el-table-column label="名称" align="center" prop="name" />
          <el-table-column label="班级" align="center" prop="className" />
          <el-table-column label="选科" align="center" prop="subject" />
          <el-table-column label="总分原始分" align="center" prop="score" />
          <el-table-column label="总分赋分" align="center" prop="scoreSum" />
          <el-table-column label="学校排名" align="center" prop="schoolRanking" />
          <el-table-column label="班级排名" align="center" prop="classRanking" />
          <el-table-column label="语文原始分" align="center" prop="yuWenScore" />
          <el-table-column label="学校排名" align="center" prop="yuWenSchoolRanking" />
          <el-table-column label="班级排名" align="center" prop="yuWenclassRanking" />
          <el-table-column label="数学原始分" align="center" prop="shuXueScore" />
          <el-table-column label="学校排名" align="center" prop="shuXueSchoolRanking" />
          <el-table-column label="班级排名" align="center" prop="shuXueClassRanking" />
          <el-table-column label="英语原始分" align="center" prop="yingYuScore" />
          <el-table-column label="学校排名" align="center" prop="yingYuSchoolRanking" />
          <el-table-column label="班级排名" align="center" prop="yingYuClassRanking" />

          <el-table-column label="物理原始分" align="center" prop="wuLiScore" />
          <el-table-column label="物理赋分" align="center" prop="wuLiScoreSum" />
          <el-table-column label="学校排名" align="center" prop="wuLiSchoolRanking" />
          <el-table-column label="班级排名" align="center" prop="wuLiClassRanking" />

          <el-table-column label="化学原始分" align="center" prop="huaXueScore" />
          <el-table-column label="化学赋分" align="center" prop="huaXueScoreSum" />
          <el-table-column label="学校排名" align="center" prop="huaXueSchoolRanking" />
          <el-table-column label="班级排名" align="center" prop="huaXueClassRanking" />

          <el-table-column label="生物原始分" align="center" prop="shengWuScore" />
          <el-table-column label="生物赋分" align="center" prop="shengWuScoreSum" />
          <el-table-column label="学校排名" align="center" prop="shengWuSchoolRanking" />
          <el-table-column label="班级排名" align="center" prop="shengWuClassRanking" />

          <el-table-column label="政治原始分" align="center" prop="zhengZhiScore" />
          <el-table-column label="政治赋分" align="center" prop="zhengZhiScoreSum" />
          <el-table-column label="学校排名" align="center" prop="zhengZhiSchoolRanking" />
          <el-table-column label="班级排名" align="center" prop="zhengZhiClassRanking" />

          <el-table-column label="历史原始分" align="center" prop="liShiScore" />
          <el-table-column label="历史赋分" align="center" prop="liShiScoreSum" />
          <el-table-column label="学校排名" align="center" prop="liShiSchoolRanking" />
          <el-table-column label="班级排名" align="center" prop="liShiClassRanking" />

          <el-table-column label="地理原始分" align="center" prop="diLiScore" />
          <el-table-column label="地理赋分" align="center" prop="diLiScoreSum" />
          <el-table-column label="学校排名" align="center" prop="diLiSchoolRanking" />
          <el-table-column label="班级排名" align="center" prop="diLiClassRanking" />

          
          
          
          <el-table-column label="操作" align="center" class-name="small-padding fixed-width">
            <template #default="scope">
              <el-tooltip content="修改" placement="top">
                <el-button link type="primary" icon="Edit" @click="handleUpdate(scope.row)" v-hasPermi="['school:score:edit']"></el-button>
              </el-tooltip>
              <el-tooltip content="删除" placement="top">
                <el-button link type="primary" icon="Delete" @click="handleDelete(scope.row)" v-hasPermi="['school:score:remove']"></el-button>
              </el-tooltip>
            </template>
          </el-table-column>
        </el-table>
  
        <pagination
            v-show="total>0"
            :total="total"
            v-model:page="queryParams.pageNum"
            v-model:limit="queryParams.pageSize"
            @pagination="getList"
        />
      </el-card>
      <!-- 添加或修改成绩对话框 -->
      <el-dialog :title="dialog.title" v-model="dialog.visible" width="500px" append-to-body>
        <el-form ref="scoreFormRef" :model="form" :rules="rules" label-width="80px">
          <el-form-item label="姓名" prop="name">
            <el-input v-model="form.name" placeholder="请输入姓名" />
          </el-form-item>
          <el-form-item label="学号" prop="studentNumber">
            <el-input v-model="form.studentNumber" placeholder="请输入学号" />
          </el-form-item>
          <el-form-item label="科目" prop="subject">
            <el-input v-model="form.subject" placeholder="请输入科目" />
          </el-form-item>
          <el-form-item label="成绩" prop="score">
            <el-input v-model="form.score" placeholder="请输入成绩" />
          </el-form-item>
          <el-form-item label="科目排名" prop="subjectRanking">
            <el-input v-model="form.subjectRanking" placeholder="请输入科目排名" />
          </el-form-item>
          <el-form-item label="班级排名" prop="classRanking">
            <el-input v-model="form.classRanking" placeholder="请输入班级排名" />
          </el-form-item>
          <el-form-item label="学校排名" prop="schoolRanking">
            <el-input v-model="form.schoolRanking" placeholder="请输入学校排名" />
          </el-form-item>
          <el-form-item label="联考排名" prop="jointRanking">
            <el-input v-model="form.jointRanking" placeholder="请输入联考排名" />
          </el-form-item>
          <el-form-item label="选择班级" prop="lightenId">
            <el-select v-model="form.lightenId" placeholder="请选择班级">
              <el-option v-for="(value,index) in lightenList" :key="index" :label="value.name" :value="value.id"></el-option>
            </el-select>
          </el-form-item>
          <el-form-item label="选择档案" prop="recordId">
            <el-select v-model="form.recordId" placeholder="请选择档案">
              <el-option v-for="(value,index) in recordList" :key="index" :label="value.title" :value="value.id"></el-option>
            </el-select>
          </el-form-item>
        </el-form>
        <template #footer>
          <div class="dialog-footer">
            <el-button :loading="buttonLoading" type="primary" @click="submitForm">确 定</el-button>
            <el-button @click="cancel">取 消</el-button>
          </div>
        </template>
      </el-dialog>
      <!-- 用户导入对话框 -->
    <el-dialog :title="upload.title" v-model="upload.open" width="400px" append-to-body>
      <el-form ref="scoreImportRef" :model="upload" :rules="ruless" label-width="80px">
        <el-form-item label="选择班级" prop="lightenId">
          <el-select v-model="upload.lightenId" placeholder="请选择班级">
            <el-option v-for="(value,index) in lightenList" :key="index" :label="value.name" :value="value.id"></el-option>
            
          </el-select>
        </el-form-item>
        <el-form-item label="选择档案" prop="recordId">
          <el-select v-model="upload.recordId" placeholder="请选择档案">
            <el-option v-for="(value,index) in recordList" :key="index" :label="value.title" :value="value.id"></el-option>
            
          </el-select>
        </el-form-item>
        <el-upload
          ref="uploadRef"
          :limit="1"
          accept=".xlsx, .xls"
          :headers="upload.headers"
          :action="upload.url + '?updateSupport=' + upload.updateSupport + '&lightenId=' + upload.lightenId + '&recordId=' + upload.recordId"
          :disabled="upload.isUploading"
          :on-progress="handleFileUploadProgress"
          :on-success="handleFileSuccess"
          :auto-upload="false"
          drag
        >
          <el-icon class="el-icon--upload">
            <i-ep-upload-filled />
          </el-icon>
          <div class="el-upload__text">将文件拖到此处，或<em>点击上传</em></div>
          <template #tip>
            <div class="text-center el-upload__tip">
              <div class="el-upload__tip"><el-checkbox v-model="upload.updateSupport" />是否更新已经存在的用户数据</div>
              <span>仅允许导入xls、xlsx格式文件。</span>
              <el-link type="primary" :underline="false" style="font-size:12px;vertical-align: baseline;" @click="importTemplate">下载模板</el-link>
            </div>
          </template>
        </el-upload>
      </el-form>
      
      <template #footer>
        <div class="dialog-footer">
          <el-button type="primary" @click="submitFileForm">确 定</el-button>
          <el-button @click="upload.open = false">取 消</el-button>
        </div>
      </template>
    </el-dialog>
    </div>
  </template>
  
  <script setup name="Score" lang="ts">
  import { listScore, getScore, delScore, addScore, updateScore } from '@/api/school/score';
  import { ScoreVO, ScoreQuery, ScoreForm } from '@/api/school/score/types';
  import { globalHeaders } from "@/utils/request";
  import { findLightenByUserId } from "@/api/school/lighten";
  import { LightenVO } from '@/api/school/lighten/types';
  import { listAllRecord } from '@/api/school/record';
  import { RecordVO } from '@/api/school/record/types';

  const { proxy } = getCurrentInstance() as ComponentInternalInstance;
  
  const scoreList = ref<ScoreVO[]>([]);
  const lightenList = ref<LightenVO[]>([]);
  const recordList = ref<RecordVO[]>([]);
  const buttonLoading = ref(false);
  const loading = ref(true);
  const showSearch = ref(true);
  const ids = ref<Array<string | number>>([]);
  const single = ref(true);
  const multiple = ref(true);
  const total = ref(0);
  /*** 用户导入参数 */
  const upload = reactive<ImportOption>({
    // 是否显示弹出层（用户导入）
    open: false,
    // 弹出层标题（用户导入）
    title: "",
    // 是否禁用上传
    isUploading: false,
    // 是否更新已经存在的用户数据
    updateSupport: 0,
    // 设置上传的请求头部
    headers: globalHeaders(),
    // 上传的地址
    url: import.meta.env.VITE_APP_BASE_API + "/school/score/importData",
    //班级
    lightenId: null,
    //档案
    recordId: null
  })
  const queryFormRef = ref<ElFormInstance>();
  const scoreFormRef = ref<ElFormInstance>();
  const scoreImportRef = ref<ElFormInstance>();
  const uploadRef = ref<ElUploadInstance>();
  const dialog = reactive<DialogOption>({
    visible: false,
    title: ''
  });

  const initFormData: ScoreForm = {
    id: undefined,
    name: undefined,
    studentNumber: undefined,
    subject: undefined,
    score: undefined,
    subjectRanking: undefined,
    classRanking: undefined,
    schoolRanking: undefined,
    jointRanking: undefined,
    recordId: undefined,
    lightenId: undefined,
  }
  const data = reactive<PageData<ScoreForm, ScoreQuery>>({
    form: {...initFormData},
    queryParams: {
      pageNum: 1,
      pageSize: 10,
      name: undefined,
      studentNumber: undefined,
      subject: undefined,
      score: undefined,
      subjectRanking: undefined,
      classRanking: undefined,
      schoolRanking: undefined,
      jointRanking: undefined,
      recordId: undefined,
      lightenId: undefined,
      params: {
      }
    },
    rules: {
      id: [
        { required: true, message: "不能为空", trigger: "blur" }
      ],
      name: [
        { required: true, message: "姓名不能为空", trigger: "blur" }
      ],
      studentNumber: [
        { required: true, message: "学号不能为空", trigger: "blur" }
      ],
      subject: [
        { required: true, message: "科目不能为空", trigger: "blur" }
      ],
      score: [
        { required: true, message: "成绩不能为空", trigger: "blur" }
      ],
      subjectRanking: [
        { required: true, message: "科目排名不能为空", trigger: "blur" }
      ],
      classRanking: [
        { required: true, message: "班级排名不能为空", trigger: "blur" }
      ],
      schoolRanking: [
        { required: true, message: "学校排名不能为空", trigger: "blur" }
      ],
      jointRanking: [
        { required: true, message: "联考排名不能为空", trigger: "blur" }
      ],
      recordId: [
        { required: true, message: "所属档案不能为空", trigger: "blur" }
      ],
    }
  });
  const ruless = {
    recordId: [
      { required: true, message: "所属档案不能为空", trigger: "blur" }
    ],
    lightenId: [
      { required: true, message: "所属班级不能为空", trigger: "blur" }
    ]
  }
  const { queryParams, form, rules} = toRefs(data);
  
  /** 查询成绩列表 */
  const getList = async () => {
    loading.value = true;
    const res = await listScore(queryParams.value);
    scoreList.value = res.rows;
    total.value = res.total;
    loading.value = false;
  }

  /** 查询班级 */
  const getLighten = async () => {
    const res = await findLightenByUserId();
    lightenList.value = res.data;
  }

  /** 查询档案 */
  const getRecord = async () => {
    const res = await listAllRecord();
    recordList.value = res.data;
  }
  
  /** 取消按钮 */
  const cancel = () => {
    reset();
    dialog.visible = false;
  }
  
  /** 表单重置 */
  const reset = () => {
    form.value = {...initFormData};
    scoreFormRef.value?.resetFields();
  }
  
  /** 搜索按钮操作 */
  const handleQuery = () => {
    queryParams.value.pageNum = 1;
    getList();
  }
  
  /** 重置按钮操作 */
  const resetQuery = () => {
    queryFormRef.value?.resetFields();
    handleQuery();
  }
  
  /** 多选框选中数据 */
  const handleSelectionChange = (selection: ScoreVO[]) => {
    ids.value = selection.map(item => item.id);
    single.value = selection.length != 1;
    multiple.value = !selection.length;
  }
  
  /** 新增按钮操作 */
  const handleAdd = () => {
    reset();
    dialog.visible = true;
    dialog.title = "添加成绩";
  }
  
  /** 修改按钮操作 */
  const handleUpdate = async (row?: ScoreVO) => {
    reset();
    const _id = row?.id || ids.value[0]
    const res = await getScore(_id);
    Object.assign(form.value, res.data);
    dialog.visible = true;
    dialog.title = "修改成绩";
  }
  
  /** 提交按钮 */
  const submitForm = () => {
    scoreFormRef.value?.validate(async (valid: boolean) => {
      if (valid) {
        buttonLoading.value = true;
        if (form.value.id) {
          await updateScore(form.value).finally(() =>  buttonLoading.value = false);
        } else {
          await addScore(form.value).finally(() =>  buttonLoading.value = false);
        }
        proxy?.$modal.msgSuccess("修改成功");
        dialog.visible = false;
        await getList();
      }
    });
  }
  
  /** 删除按钮操作 */
  const handleDelete = async (row?: ScoreVO) => {
    const _ids = row?.id || ids.value;
    await proxy?.$modal.confirm('是否确认删除成绩编号为"' + _ids + '"的数据项？').finally(() => loading.value = false);
    await delScore(_ids);
    proxy?.$modal.msgSuccess("删除成功");
    await getList();
  }
  /** 导入按钮操作 */
  const handleImport = () => {
    upload.lightenId = null;
    upload.recordId = null;
    upload.title = "成绩导入";
    upload.open = true;
    
  }
  /** 下载模板操作 */
  const importTemplate = () => {
    proxy?.download("school/score/importTemplate", {
    }, `导入成绩模板_${new Date().getTime()}.xlsx`);
  }
  /** 导出按钮操作 */
  const handleExport = () => {
    proxy?.download('school/score/export', {
      ...queryParams.value
    }, `score_${new Date().getTime()}.xlsx`)
  }
  /**文件上传中处理 */
  const handleFileUploadProgress = () => {
    upload.isUploading = true;
  }
  /** 文件上传成功处理 */
  const handleFileSuccess = (response: any, file: UploadFile) => {
    upload.open = false;
    upload.isUploading = false;
    uploadRef.value?.handleRemove(file);
    ElMessageBox.alert("<div style='overflow: auto;overflow-x: hidden;max-height: 70vh;padding: 10px 20px 0;'>" + response.msg + "</div>", "导入结果", { dangerouslyUseHTMLString: true });
    getList();
  }

  /** 提交上传文件 */
  function submitFileForm() {
    scoreImportRef.value?.validate(async (valid: boolean) => {
      if (valid) {
        uploadRef.value?.submit();
      }
    });
    
  }
  onMounted(() => {
    getList();
    getLighten();
    getRecord();
  });
  </script>
  